Snowflake DWH

Please enter the following parameters to connect to a Snowflake data source:

• Host: IP address or hostname of the server where the data source is running
• SSL: use encrypted connection (available for Redshift data source)
• Schema / Database : schema / database name of the Redshift data source to connect to
• User name / Password: credentials to connect to data source
• Warehouse: name of the Warehouse to connect to the data source
• Data source parameters: additional connection parameters
• Translator parameters: additional translator parameters
• JDBC parameters: additional JDBC parameters

Below are some examples of the most common data source parameters, see the reference manual for the full list:

• importer.useFullSchemaName=TRUE - schema names will be prefixed to table names to avoid duplicates
• importer.importProcedures=TRUE - stored procedures will be imported
• importer.useProcedureSpecificName=TRUE - when two stored procedures being imported have identical names, an index will be appended to their names in order to avoid conflicts

Select AWS S3 Load or Azure Blob Storage Load to configure the Upload Mode. Check the online documentation for details.

To test the connection parameters press the Test connection button.